
<aside class="main-sidebar">
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
        <ul class="sidebar-menu">
            <li class="header">欢迎</li>
            <li class="active treeview">
                <a href="#">
                    <i class="fa fa-dashboard"></i> <span>数据统计</span> <i class="fa fa-angle-left pull-right"></i>
                </a>
                <ul class="treeview-menu">
                    <li class="active"><a href="index.php?p=cpaSearch"><i class="fa fa-circle-o"></i>查询</a></li>
                </ul>
            </li>
        </ul>
    </section>
    <!-- /.sidebar -->
</aside>
<!-- Main content -->
<div class="content-wrapper" onclick="changePassDivHide()">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            数据统计
            <small>查询</small>
        </h1>
    </section>
        <section class="content">
            <div class="row">

                    <div class="col-md-4 date">
                        <form action="index.php" method="get">
                            <h4>日期选择</h4>
                            <input type="text" id="date-range_picker" name="dateRange" class="form-control">
                            <i class="glyphicon glyphicon-calendar fa fa-calendar"></i>
                        </form>
                    </div>
                <div class="col-md-3">
                    <h4>产品名称查询</h4>
                    <select class="form-control" id="data-search">
                        <option  selected="true" value="全部产品">全部产品</option>
                        <?php
                        session_start();
                        $pipe_username=$_SESSION['pipe_username'];
                                $rows = $mysql->query("select `product_name` from `pipe` where `pipe_username` = '{$pipe_username}'");
                        foreach($rows as $row){
                        echo "<option value=".$row['product_name'].">".$row['product_name']."</option>";
                        }
                        ?>
                    </select>
                </div>
            </div>
            <div class="row">
                <div class="col-xs-12">
                    <h5 id="num"></h5>
                </div>
            </div>
            <div class="row">
                <div class="col-xs-12">
                    <div class="box">
                        <div class="box-body">
                            <table id="example2" class="table table-bordered table-hover">

                            </table>
                        </div><!-- /.box-body -->
                </div><!-- /.col -->
             </div><!-- /.row -->
            </div><!-- /.row -->
            <div class="row">
                <div class="col-xs-12">
                    <nav>
                        <ul class="pagination">
                            <li>
                                <a href="#" aria-label="Previous">
                                    <span aria-hidden="true">«</span>
                                </a>
                            </li>
                            <li><a href="#" id="page-current">1</a></li>
                            <li>
                                <a href="#" aria-label="Next">
                                    <span aria-hidden="true">»</span>
                                </a>
                            </li>
                        </ul>
                    </nav>
                </div>
            </div>
        </section><!-- /.content -->
    </div>